Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext

RE: DECS Data Translation Query
~Umberto Nongeroson 1.Dec.03 09:16 PM a Web browser
General 6.0.2 CF2 Windows 2003


First, note that there's a separate EI forum for this sort of question.

I'm going by the LEI version of this form, because that's what's handy at the moment, so excuse me if it doesn't exactly match what's on your screen.

When you create a DECS connection document to a Notes database, you should see a field giving you the option to "enforce form design". That enables computed fields.

If you don't want to do that, under Data Transformation find, "Formula to Execute Prior to Update", where @SetField or a FIELD statement should work. Note, however, that the formula you enter here should either return a value or include a SELECT statement, e.g.:

SELECT @All;
FIELD DATAC:=DATAA & "-" & DATAB





DECS Data Translation Query (~Joseph Rejipyc... 21.Nov.03)
. . RE: DECS Data Translation Query (~Bill Frokimari... 1.Dec.03)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS